package com.hawthorn.redis.repository.provider;

import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo 菜单缓存sql类</p>
 *
 * @version v1.0.2
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2021/11/28 4:59 PM
 * @copyright: Copyright (c)  andyten
 */
public class MenuCacheSqlProvider implements ProviderMethodResolver {
    public static String selectMenus() {
        String sql = "select " +
                "id, " +
                "code, " +
                "title, " +
                "title_en, " +
                "parent_id, " +
                "url, " +
                "component, " +
                "component_name, " +
                "type," +
                "order_num, " +
                "cache, " +
                "icon, " +
                "hidden, " +
                "path, " +
                "perms, " +
                "external " +
                "from sys_menu " +
                "where del_flag = 0 " +
                // "and status= " + DicConstant.YXBS_01 +
                "order by parent_id,order_num";

        return sql;
    }
}
